home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
ss
/
getsheet.zip
/
GETSHT.DOC
< prev
Wrap
Text File
|
1986-10-23
|
2KB
|
52 lines
GETSHEET
A File Extraction Program
for use with
Lotus 1-2-3 Spreadsheets
R. Fuller
If you've ever tried swapping data between programs like Lotus
1-2-3 and dBASE, you've probably run across a few difficulties
with file formats.
Most programs will write their data to a file in a format that
is more or less a "standard" interchange format that other
programs will read. This ASCII interchange format is an offshoot
of the type of files that BASIC programs seem to be comfortable
with. Under this convention, each "field" in a record or file is
separated from other fields with a comma, and alpha-numeric
strings are enclosed in double quotation marks. This is the
format that dBASE II and dBASE III refer to as 'DELIMITED WITH
"'. This is also the exact format that Lotus will accept for its
/File Import function.
But Lotus is notorious for NOT being able to EXPORT data in
the same format that it will use to input it! (Try converting a
Lotus spreadsheet BACK to a Visicalc file!) And 123's conversion
utility to convert spreadsheet data to a dBASE format generally
yields disappointing results...
GETSHEET was written in an effort to circumvent some of these
problems. The program should accept ANY 1-2-3 spreadsheet and
create an ASCII output file in the above described format that
may be used as input to another program.
The program will accept the names of two files on the command
line. The first is the name of the spreadsheet to be converted.
The second is the name of the file to be created. If either or
both names are omitted, the program will prompt for the required
names. If no extensions (file types) are specified, the default
extension of .WKS is assumed for the input file, and .PRN is
assumed for the output file.
Don't be concerned about the program destroying your
spreadsheet. The program ONLY READS the spreadsheet file.
If you encounter a bug or two, please be patient, I'm still
shaking out the logic.
I hope you get some use from this program... good luck.
R. Fuller